Parameter


A PARAMETER as defined in Access 7.0, is a criteria prompt for information from the user. A parameter query is useful if the same query is repeatedly run with different criteria. Parameter queries allow users to change the criteria but maintain the same query design grid each time the query is run.

EXAMPLE: To run a query to return records containing a certain date, create a parameter query prompting the user to enter a date. then, all records with that date are returned.